CREATE VIEW [dbo].[vUnofferedCustomerExperience]
AS
SELECT
    [dbo].[ExperienceDefinition].[ExperienceDefinitionKey],
    [dbo].[ExperienceDefinition].[ExperienceDefinitionName],
    [dbo].[ExperienceDefinition].[ExperienceDefinitionCode],
    [dbo].[ExperienceDefinition].[ExperienceDefinitionDesc],
    [dbo].[ExperienceDefinition].[NumberOfUnits],
    [dbo].[ExperienceDefinition].[RequiresGradeFlag],
    [dbo].[ExperienceDefinition].[RequiresApprovalFlag],
    [dbo].[ExperienceDefinition].[ExperienceDefinitionLocation],
    [dbo].[UnofferedCustomerExperience].[CompletionDate] AS 'ExperienceDefinitionDate',
    [dbo].[ExperienceDefinition].[ExperienceDefinitionStatusCode],
    [dbo].[Program].[ProgramName],
    [dbo].[Program].[UserDefinedExperiencesFlag],
    [dbo].[Program].[UomKey],
    [dbo].[Program].[MinimumValue],
    [dbo].[Program].[MaximumValue],
    [dbo].[Program].[ProgramDescr],
    [dbo].[Program].[ProgramStatusCode],
    [dbo].[UnofferedCustomerExperience].[UnofferedCustomerExperienceKey],
    [dbo].[UnofferedCustomerExperience].[UnofferedCustomerExperienceGrade],
    [dbo].[Program].[ProgramKey]

FROM
    [dbo].[UnofferedCustomerExperience]
        INNER JOIN [dbo].[ExperienceDefinition] ON [dbo].[UnofferedCustomerExperience].[ExperienceDefinitionKey] = [dbo].[ExperienceDefinition].[ExperienceDefinitionKey]
        INNER JOIN [dbo].[Program] ON [dbo].[ExperienceDefinition].[ProgramKey] = [dbo].[Program].[ProgramKey]

GO